(
 SELECT b.*, a.bg_mp_scope FROM bg_mps_00001 AS a INNER JOIN 
 ((SELECT * FROM collect_001_products) UNION (SELECT * FROM collect_002_products)) AS b ON a.collect_product_id = b.collect_product_id 
 WHERE a.bg_keyword_char_id = 10020000001
)

UNION

(SELECT *, '0' as bg_mp_scope FROM 
	((SELECT * FROM collect_001_products WHERE collect_product_title LIKE '%¹qµø%') UNION (SELECT * FROM collect_002_products WHERE collect_product_title LIKE '%¹qµø%')) AS product 
 WHERE product.collect_product_id NOT IN ( 
		SELECT collect_product_id FROM bg_mps_00001 WHERE bg_keyword_char_id = 10020000001
 )
) ORDER BY bg_mp_scope DESC